import cufflinks as cf
import pandas as pd
import numpy as np
import plotly.offline as py
import plotly.graph_objs as go
from IPython.display import display, Markdown, Latex
py.init_notebook_mode(connected=True)
cf.set_config_file(offline=True)
pd.options.display.float_format = '{:20,.2f}'.format
# main data-frame init
dtype = {'County': np.str,
'Employee Name': np.str,
'Job Title': np.str,
'Year': np.int64,
'Notes': np.str,
'Agency': np.str,
'Status': np.str}
def to_float(x):
try:
return float(x)
except Exception as e:
return None
converters = {'Base Pay': to_float,
'Overtime Pay': to_float,
'Other Pay': to_float,
'Benefits': to_float,
'Total Pay': to_float,
'Total Pay & Benefits': to_float}
df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
# definitions
ENTITIES_MAPPING = {
'Teachers': '(?i)teacher|tchr',
'Managers': '(?i)principal|director|chief|intendent|administrator|coordinator|mgr',
'Superintendents': '(?i)superintendent|supt'
}
ENTITIES = ['Teachers', 'Managers', 'Superintendents']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
HIGHLIGHT_AGECNY = 'San Mateo-Foster City'
def get_df(county, entity, year):
return df[(df['County'] == county) &
(df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) &
(df['Year'] == year)]
def display_mean_salary_by_year(county, entity, year):
ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
ga_mean = ga.mean()
ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
bar = go.Bar(x=ga_mean['Agency'],
y=ga_mean['Total Pay & Benefits'],
marker=dict(color=np.where(ga_mean['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
layout = go.Layout(
margin=go.Margin(
l=60,
r=50,
b=150,
t=100,
pad=2
),
title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
xaxis=dict(
title='Agency',
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
),
yaxis=dict(
title='Mean Salary (USD)',
titlefont=dict(
size=16,
color='rgb(107, 107, 107)'
),
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
)
)
fig = go.Figure(data=[bar], layout=layout)
py.offline.iplot(fig, filename='basic-bar')
"""
ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county,
entity=entity,
year=year),
x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
"""
# print table under graph
ga_descr = ga.describe()
#ga_descr[ga_descr.columns] = ga_descr[ga_descr.columns].fillna(0).astype(np.int64)
display(ga_descr.sort_values(by='mean', ascending=False))
def display_cumul_salary_change(county, entity, year_from, year_to):
dt = df[(df['County'] == county) &
(df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) &
((df['Year'] == year_from) | (df['Year'] == year_to))]
dt = dt.groupby(['Agency', 'Year'])['Total Pay & Benefits'].mean().to_frame().reset_index()
dt = dt.pivot_table(columns=['Year'], values='Total Pay & Benefits', index=['Agency']).reset_index()
dt.columns = ['Agency', 'year_from', 'year_to'] # because numbers in column names doesn't work
dt['diff'] = dt.apply(lambda row: (row['year_to'] - row['year_from']) * 100 / row['year_from'], axis=1)
dt = dt[(dt['diff'].notnull())]
dt = dt.sort_values(by='diff', ascending=False)
bar = go.Bar(x=dt['Agency'],
y=dt['diff'],
marker=dict(color=np.where(dt['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
layout = go.Layout(
margin=go.Margin(
l=60,
r=50,
b=150,
t=100,
pad=2
),
title='{county}, {entity}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
entity=entity,
year_from=year_from,
year_to=year_to),
xaxis=dict(
title='Agency',
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
),
yaxis=dict(
title='Salary Change (%)',
titlefont=dict(
size=16,
color='rgb(107, 107, 107)'
),
tickfont=dict(
size=14,
color='rgb(107, 107, 107)'
)
)
)
fig = go.Figure(data=[bar], layout=layout)
py.offline.iplot(fig, filename='basic-bar')
# Salary change
year_from = min(YEARS)
year_to = max(YEARS)
for county in COUNTIES:
display(Markdown('# {county}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
year_from=year_from,
year_to=year_to)))
for entity in ENTITIES:
display(Markdown('## {entity}'.format(entity=entity)))
display_cumul_salary_change(county, entity, year_from, year_to)
# Mean salary
year_from = min(YEARS)
year_to = max(YEARS)
for county in COUNTIES:
display(Markdown('# {county}, Mean Salary in {year_from} - {year_to}'.format(county=county,
year_from=year_from,
year_to=year_to)))
for year in YEARS:
display(Markdown('## {year}'.format(year=year)))
for entity in ENTITIES:
display(Markdown('### {entity}'.format(entity=entity)))
display_mean_salary_by_year(county, entity, year)
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 51.00 | 114,308.22 | 35,249.92 | 24,441.29 | 103,155.85 | 121,072.10 | 141,348.27 | 155,939.98 |
| Las Lomitas Elementary | 86.00 | 112,186.29 | 34,589.27 | 17,674.21 | 101,644.44 | 124,789.11 | 135,003.10 | 162,679.42 |
| Menlo Park City Elementary | 197.00 | 109,100.83 | 31,872.65 | 4,772.96 | 93,540.96 | 120,378.59 | 132,307.00 | 149,728.85 |
| San Mateo Union High | 516.00 | 89,637.90 | 55,348.64 | 0.00 | 43,487.97 | 110,342.98 | 136,326.11 | 177,103.02 |
| Redwood City Elementary | 414.00 | 84,091.86 | 30,399.76 | 3,467.76 | 66,821.58 | 90,014.50 | 108,050.12 | 130,262.17 |
| San Mateo County Office of Education | 98.00 | 81,386.74 | 51,924.93 | 161.00 | 34,584.75 | 87,253.00 | 130,387.50 | 162,407.00 |
| San Mateo-Foster City | 671.00 | 80,915.34 | 34,628.19 | 0.00 | 56,369.85 | 88,089.60 | 109,455.35 | 130,813.29 |
| San Carlos Elementary | 179.00 | 80,820.37 | 30,054.58 | 10,515.54 | 62,665.38 | 93,103.93 | 101,742.90 | 118,654.71 |
| Belmont-Redwood Shores Elementary | 212.00 | 80,434.73 | 30,277.63 | 1.00 | 63,843.00 | 84,095.00 | 104,613.75 | 141,135.00 |
| Pacifica School District | 166.00 | 78,638.99 | 31,585.52 | 0.00 | 56,373.25 | 88,943.20 | 105,053.93 | 126,200.80 |
| South San Francisco Unified | 361.00 | 76,595.15 | 26,264.21 | 0.00 | 65,551.00 | 79,782.00 | 96,918.00 | 127,910.00 |
| Burlingame Elementary | 184.00 | 74,049.30 | 27,328.24 | 4,156.15 | 54,526.63 | 77,799.64 | 96,986.45 | 116,783.89 |
| Bayshore Elementary | 23.00 | 71,390.65 | 24,179.92 | 23,153.00 | 64,017.00 | 76,141.00 | 85,656.50 | 102,482.00 |
| La Honda-Pescadero Unified | 38.00 | 66,915.00 | 30,181.64 | 24.70 | 47,218.51 | 72,050.93 | 87,400.46 | 124,795.88 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 8.00 | 177,613.95 | 61,283.00 | 42,479.98 | 176,001.38 | 185,905.33 | 199,468.78 | 246,767.16 |
| Menlo Park City Elementary | 18.00 | 173,413.65 | 37,883.54 | 98,821.54 | 147,614.50 | 172,950.27 | 196,669.25 | 274,717.64 |
| San Mateo-Foster City | 47.00 | 163,747.96 | 47,401.06 | 43,060.05 | 146,228.26 | 180,012.11 | 192,097.29 | 270,074.32 |
| Burlingame Elementary | 17.00 | 156,509.58 | 46,148.23 | 64,474.57 | 137,023.89 | 151,988.99 | 172,007.33 | 293,857.48 |
| Pacifica School District | 17.00 | 146,165.94 | 53,597.25 | 14,546.44 | 131,817.65 | 150,180.96 | 162,938.29 | 248,636.70 |
| San Mateo Union High | 48.00 | 144,990.26 | 81,074.66 | 0.00 | 81,295.07 | 171,328.46 | 205,726.11 | 348,435.74 |
| Belmont-Redwood Shores Elementary | 18.00 | 144,171.11 | 38,923.05 | 78,340.00 | 118,907.00 | 147,838.50 | 166,497.75 | 234,988.00 |
| San Mateo County Office of Education | 66.00 | 138,959.92 | 60,035.16 | 307.00 | 103,615.00 | 161,025.50 | 170,897.75 | 272,407.00 |
| Las Lomitas Elementary | 14.00 | 133,539.24 | 66,527.87 | 7,660.25 | 86,047.24 | 154,019.27 | 177,037.73 | 248,142.92 |
| San Carlos Elementary | 20.00 | 130,715.05 | 53,636.19 | 11,095.54 | 119,545.74 | 135,984.28 | 155,519.22 | 238,839.36 |
| South San Francisco Unified | 31.00 | 126,889.58 | 48,697.40 | 0.00 | 85,846.50 | 142,932.00 | 158,596.00 | 225,309.00 |
| Redwood City Elementary | 64.00 | 124,707.83 | 45,997.44 | 44,739.55 | 80,486.20 | 131,188.83 | 160,821.58 | 268,113.54 |
| Bayshore Elementary | 5.00 | 107,142.00 | 55,260.83 | 54,525.00 | 56,846.00 | 101,871.00 | 138,462.00 | 184,006.00 |
| La Honda-Pescadero Unified | 8.00 | 88,910.23 | 42,648.93 | 20,385.03 | 53,595.81 | 101,808.99 | 120,146.37 | 138,866.25 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 3.00 | 290,160.61 | 58,516.90 | 231,404.91 | 261,023.05 | 290,641.19 | 319,538.46 | 348,435.74 |
| Redwood City Elementary | 1.00 | 268,113.54 | nan | 268,113.54 | 268,113.54 | 268,113.54 | 268,113.54 | 268,113.54 |
| Portola Valley Elementary | 1.00 | 246,767.16 | nan | 246,767.16 | 246,767.16 | 246,767.16 | 246,767.16 | 246,767.16 |
| Menlo Park City Elementary | 2.00 | 243,201.23 | 44,570.94 | 211,684.81 | 227,443.02 | 243,201.23 | 258,959.43 | 274,717.64 |
| San Mateo-Foster City | 5.00 | 234,524.79 | 62,380.28 | 124,306.70 | 246,211.83 | 261,924.45 | 270,074.32 | 270,106.67 |
| San Mateo County Office of Education | 5.00 | 229,732.20 | 26,019.06 | 204,120.00 | 215,341.00 | 225,221.00 | 231,572.00 | 272,407.00 |
| Pacifica School District | 2.00 | 224,064.61 | 34,750.18 | 199,492.52 | 211,778.57 | 224,064.61 | 236,350.66 | 248,636.70 |
| Burlingame Elementary | 3.00 | 221,090.65 | 63,018.18 | 184,528.35 | 184,707.23 | 184,886.11 | 239,371.79 | 293,857.48 |
| San Carlos Elementary | 2.00 | 211,754.71 | 38,303.48 | 184,670.06 | 198,212.38 | 211,754.71 | 225,297.03 | 238,839.36 |
| Bayshore Elementary | 1.00 | 184,006.00 | nan | 184,006.00 | 184,006.00 | 184,006.00 | 184,006.00 | 184,006.00 |
| Belmont-Redwood Shores Elementary | 2.00 | 175,290.50 | 84,425.01 | 115,593.00 | 145,441.75 | 175,290.50 | 205,139.25 | 234,988.00 |
| South San Francisco Unified | 3.00 | 169,704.00 | 66,012.77 | 96,749.00 | 141,901.50 | 187,054.00 | 206,181.50 | 225,309.00 |
| Las Lomitas Elementary | 2.00 | 164,871.74 | 117,763.23 | 81,600.56 | 123,236.15 | 164,871.74 | 206,507.33 | 248,142.92 |
| La Honda-Pescadero Unified | 2.00 | 113,445.35 | 35,950.58 | 88,024.45 | 100,734.90 | 113,445.35 | 126,155.80 | 138,866.25 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 388.00 | 117,053.42 | 38,169.12 | 1,199.06 | 97,240.68 | 129,096.21 | 146,170.96 | 195,573.51 |
| Menlo Park City Elementary | 210.00 | 106,634.16 | 38,686.06 | 1,314.29 | 85,142.04 | 121,874.85 | 136,013.63 | 152,600.47 |
| Woodside Elementary | 39.00 | 105,741.35 | 32,786.61 | 35,032.81 | 85,672.04 | 115,348.25 | 127,850.42 | 165,303.09 |
| Hillsborough City Elementary | 135.00 | 105,162.21 | 36,274.90 | 14,200.68 | 82,639.96 | 117,400.88 | 132,841.88 | 156,858.61 |
| San Carlos Elementary | 180.00 | 83,407.44 | 27,958.95 | 466.41 | 71,778.05 | 93,333.76 | 103,788.60 | 120,869.68 |
| San Mateo-Foster City | 629.00 | 83,212.40 | 29,649.92 | 0.00 | 66,751.62 | 90,426.97 | 106,376.27 | 130,413.40 |
| Cabrillo Unified | 184.00 | 81,777.17 | 34,833.83 | 881.28 | 62,324.38 | 85,248.49 | 110,965.51 | 151,335.71 |
| South San Francisco Unified | 462.00 | 79,156.75 | 26,248.53 | 7,958.79 | 66,955.60 | 84,441.05 | 100,269.82 | 134,160.62 |
| Jefferson Elementary | 352.00 | 78,553.44 | 29,733.54 | 1,159.30 | 62,450.78 | 85,683.54 | 101,899.68 | 130,453.74 |
| Las Lomitas Elementary | 147.00 | 76,413.64 | 60,059.38 | 0.00 | 5,274.05 | 96,178.84 | 131,790.18 | 164,809.81 |
| Pacifica School District | 167.00 | 74,941.96 | 32,807.89 | 279.69 | 44,251.46 | 84,648.41 | 102,492.52 | 124,831.43 |
| Millbrae Elementary | 145.00 | 72,698.63 | 31,377.97 | 1,219.43 | 42,626.00 | 78,673.19 | 100,827.27 | 122,979.02 |
| La Honda-Pescadero Unified | 37.00 | 72,450.63 | 33,348.15 | 66.35 | 60,311.79 | 80,146.95 | 92,991.62 | 129,516.80 |
| Belmont-Redwood Shores Elementary | 293.00 | 62,663.58 | 44,117.38 | 75.50 | 17,713.82 | 70,308.95 | 101,781.41 | 138,947.88 |
| Redwood City Elementary | 683.00 | 58,250.73 | 40,445.78 | 0.00 | 18,701.51 | 59,961.68 | 97,720.35 | 127,244.90 |
| Bayshore Elementary | 26.00 | 57,759.40 | 28,857.41 | 3,612.80 | 34,075.67 | 65,248.93 | 75,227.95 | 103,615.24 |
| Burlingame Elementary | 289.00 | 52,548.26 | 39,689.07 | 0.00 | 10,129.91 | 52,903.21 | 91,831.64 | 115,200.73 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 9.00 | 180,800.32 | 48,691.11 | 89,546.44 | 178,676.13 | 188,815.96 | 201,455.00 | 253,150.62 |
| San Mateo-Foster City | 45.00 | 163,453.69 | 38,300.74 | 55,680.49 | 150,691.84 | 178,892.65 | 187,747.81 | 209,969.37 |
| San Mateo Union High | 48.00 | 162,372.42 | 56,422.34 | 40,899.38 | 120,110.58 | 170,361.15 | 202,151.73 | 330,816.69 |
| Burlingame Elementary | 16.00 | 158,781.12 | 56,372.03 | 60,098.64 | 149,678.27 | 163,433.36 | 182,022.72 | 300,712.30 |
| Las Lomitas Elementary | 13.00 | 154,780.36 | 60,250.47 | 42,041.51 | 98,274.71 | 178,123.46 | 195,590.94 | 235,632.38 |
| San Carlos Elementary | 17.00 | 148,119.06 | 41,460.94 | 65,947.53 | 133,616.68 | 150,414.23 | 160,459.65 | 246,861.84 |
| Woodside Elementary | 10.00 | 146,346.10 | 56,557.11 | 96,975.96 | 106,643.71 | 132,557.42 | 164,218.93 | 287,480.51 |
| Menlo Park City Elementary | 22.00 | 144,039.27 | 70,105.08 | 1,320.89 | 90,810.63 | 160,612.41 | 199,705.55 | 269,385.57 |
| Pacifica School District | 16.00 | 143,586.61 | 51,778.18 | 49,589.52 | 117,958.86 | 148,467.15 | 170,896.62 | 237,194.10 |
| Belmont-Redwood Shores Elementary | 18.00 | 136,505.66 | 62,247.33 | 1,480.75 | 119,556.50 | 161,408.12 | 172,981.58 | 233,844.88 |
| Jefferson Elementary | 33.00 | 131,931.96 | 46,705.99 | 11,055.74 | 113,202.78 | 149,025.20 | 156,861.90 | 244,588.82 |
| South San Francisco Unified | 35.00 | 131,053.26 | 37,018.92 | 37,939.40 | 114,083.72 | 143,519.45 | 149,974.70 | 205,408.48 |
| Cabrillo Unified | 26.00 | 119,746.42 | 40,810.63 | 33,606.67 | 94,466.94 | 125,645.21 | 147,493.99 | 200,071.38 |
| Redwood City Elementary | 69.00 | 114,775.72 | 48,898.52 | 2,501.31 | 81,115.01 | 119,202.99 | 154,442.34 | 223,152.08 |
| Millbrae Elementary | 14.00 | 114,471.56 | 51,463.79 | 48,777.38 | 61,762.23 | 123,167.40 | 152,566.90 | 185,831.11 |
| La Honda-Pescadero Unified | 8.00 | 100,584.11 | 42,463.12 | 39,869.34 | 58,961.45 | 120,584.01 | 131,331.61 | 144,991.75 |
| Bayshore Elementary | 5.00 | 87,705.18 | 30,488.51 | 56,680.98 | 63,276.75 | 89,705.70 | 95,373.64 | 133,488.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Woodside Elementary | 1.00 | 287,480.51 | nan | 287,480.51 | 287,480.51 | 287,480.51 | 287,480.51 | 287,480.51 |
| Hillsborough City Elementary | 1.00 | 253,150.62 | nan | 253,150.62 | 253,150.62 | 253,150.62 | 253,150.62 | 253,150.62 |
| Menlo Park City Elementary | 2.00 | 241,436.48 | 39,525.98 | 213,487.40 | 227,461.94 | 241,436.48 | 255,411.03 | 269,385.57 |
| San Mateo Union High | 4.00 | 238,103.05 | 64,154.91 | 184,304.04 | 204,750.93 | 218,645.73 | 251,997.85 | 330,816.69 |
| Las Lomitas Elementary | 1.00 | 235,632.38 | nan | 235,632.38 | 235,632.38 | 235,632.38 | 235,632.38 | 235,632.38 |
| Burlingame Elementary | 3.00 | 227,565.73 | 63,431.13 | 187,722.55 | 190,992.44 | 194,262.33 | 247,487.32 | 300,712.30 |
| San Carlos Elementary | 2.00 | 217,249.02 | 41,878.86 | 187,636.19 | 202,442.60 | 217,249.02 | 232,055.43 | 246,861.84 |
| Pacifica School District | 2.00 | 211,077.69 | 36,934.18 | 184,961.28 | 198,019.48 | 211,077.69 | 224,135.90 | 237,194.10 |
| San Mateo-Foster City | 5.00 | 197,145.78 | 64,760.12 | 122,130.64 | 132,572.30 | 226,671.96 | 247,185.88 | 257,168.11 |
| Jefferson Elementary | 5.00 | 184,087.31 | 54,613.49 | 101,801.80 | 173,838.48 | 179,114.36 | 221,093.07 | 244,588.82 |
| Redwood City Elementary | 2.00 | 177,061.68 | 65,181.67 | 130,971.28 | 154,016.48 | 177,061.68 | 200,106.88 | 223,152.08 |
| South San Francisco Unified | 4.00 | 169,479.33 | 25,143.86 | 151,963.97 | 152,162.23 | 160,272.43 | 177,589.52 | 205,408.48 |
| La Honda-Pescadero Unified | 1.00 | 144,991.75 | nan | 144,991.75 | 144,991.75 | 144,991.75 | 144,991.75 | 144,991.75 |
| Millbrae Elementary | 3.00 | 130,687.48 | 45,599.92 | 97,746.70 | 104,665.14 | 111,583.57 | 147,157.88 | 182,732.18 |
| Cabrillo Unified | 5.00 | 120,942.59 | 34,903.87 | 83,882.00 | 108,345.55 | 108,645.35 | 126,715.60 | 177,124.43 |
| Belmont-Redwood Shores Elementary | 3.00 | 116,929.98 | 115,045.04 | 3,850.73 | 58,472.53 | 113,094.34 | 173,469.61 | 233,844.88 |
| Bayshore Elementary | 1.00 | 89,705.70 | nan | 89,705.70 | 89,705.70 | 89,705.70 | 89,705.70 | 89,705.70 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 52.00 | 105,835.64 | 37,843.49 | 19,043.07 | 84,528.15 | 118,646.98 | 136,825.63 | 150,799.05 |
| San Mateo Union High | 416.00 | 103,967.96 | 39,288.93 | 0.00 | 79,755.12 | 116,578.34 | 134,148.12 | 174,815.47 |
| Menlo Park City Elementary | 186.00 | 100,413.68 | 29,965.09 | 11,063.51 | 84,839.62 | 111,633.74 | 122,127.92 | 155,511.51 |
| Hillsborough City Elementary | 121.00 | 100,334.02 | 32,384.40 | 2,340.89 | 84,872.43 | 112,626.72 | 124,116.39 | 143,246.43 |
| San Mateo County Office of Education | 104.00 | 86,916.35 | 40,062.15 | 395.31 | 65,118.26 | 106,390.46 | 119,053.27 | 136,965.99 |
| Jefferson Elementary | 332.00 | 76,217.28 | 25,110.28 | 3,763.12 | 63,432.53 | 82,794.68 | 95,520.44 | 119,883.27 |
| Belmont-Redwood Shores Elementary | 217.00 | 74,392.10 | 30,452.18 | 3,774.79 | 49,936.49 | 80,745.93 | 100,871.89 | 126,241.04 |
| Redwood City Elementary | 495.00 | 74,273.03 | 30,093.96 | 351.67 | 48,675.15 | 77,395.72 | 99,867.10 | 121,788.88 |
| Brisbane Elementary | 37.00 | 73,454.80 | 28,064.80 | 11,053.65 | 50,678.81 | 85,438.75 | 94,788.67 | 118,708.63 |
| Pacifica School District | 165.00 | 73,329.55 | 31,912.64 | 678.11 | 44,900.92 | 83,471.82 | 100,356.14 | 121,840.67 |
| Ravenswood City Elementary | 197.00 | 71,128.68 | 25,138.88 | 0.00 | 56,524.67 | 73,807.54 | 88,427.73 | 115,228.80 |
| Millbrae Elementary | 139.00 | 71,015.98 | 30,785.37 | 17.22 | 46,388.65 | 78,047.89 | 96,976.98 | 119,780.36 |
| Las Lomitas Elementary | 148.00 | 69,855.70 | 53,581.00 | 160.59 | 7,628.11 | 78,512.02 | 120,401.01 | 150,214.89 |
| San Carlos Elementary | 166.00 | 67,331.71 | 20,636.47 | 7,099.70 | 56,748.88 | 72,876.01 | 81,953.33 | 92,283.37 |
| Jefferson Union High | 307.00 | 67,162.87 | 36,646.41 | 787.85 | 36,045.01 | 73,695.53 | 96,644.91 | 139,596.81 |
| San Bruno Park Elementary | 127.00 | 67,075.63 | 22,418.21 | 10,196.68 | 54,798.21 | 72,355.32 | 83,035.36 | 102,585.78 |
| San Mateo-Foster City | 689.00 | 66,616.08 | 39,514.74 | 0.00 | 29,700.67 | 74,407.94 | 98,813.28 | 146,467.25 |
| La Honda-Pescadero Unified | 39.00 | 65,014.45 | 30,052.89 | 12,498.98 | 37,932.88 | 63,799.98 | 91,097.86 | 111,784.48 |
| Burlingame Elementary | 300.00 | 47,605.96 | 39,188.40 | 66.00 | 3,930.75 | 47,564.80 | 84,949.23 | 109,924.81 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Hillsborough City Elementary | 10.00 | 180,388.53 | 30,067.64 | 111,214.08 | 174,417.65 | 179,081.24 | 191,583.93 | 230,110.31 |
| San Mateo Union High | 47.00 | 158,818.72 | 67,378.99 | 16,149.91 | 107,590.67 | 157,317.75 | 206,733.38 | 349,292.66 |
| Las Lomitas Elementary | 12.00 | 156,136.74 | 57,812.96 | 10,059.15 | 147,733.77 | 176,674.14 | 184,682.87 | 222,583.06 |
| Portola Valley Elementary | 7.00 | 154,660.99 | 62,167.44 | 43,745.94 | 127,323.51 | 179,101.17 | 192,935.72 | 219,261.33 |
| Menlo Park City Elementary | 17.00 | 144,489.42 | 53,016.32 | 21,375.38 | 127,400.90 | 156,662.77 | 175,083.73 | 237,957.52 |
| Burlingame Elementary | 15.00 | 144,127.19 | 46,276.51 | 85,085.58 | 113,742.41 | 147,852.91 | 159,418.66 | 269,387.20 |
| Pacifica School District | 15.00 | 142,035.24 | 48,802.13 | 54,837.09 | 123,938.61 | 152,575.98 | 162,585.12 | 229,580.87 |
| San Mateo-Foster City | 52.00 | 141,359.10 | 48,790.40 | 3,285.24 | 138,554.58 | 156,644.67 | 163,243.26 | 295,265.20 |
| San Mateo County Office of Education | 56.00 | 135,628.13 | 52,746.43 | 2,930.23 | 112,267.52 | 146,280.33 | 167,618.41 | 269,154.10 |
| Belmont-Redwood Shores Elementary | 15.00 | 131,557.14 | 45,128.99 | 62,544.65 | 97,013.68 | 139,405.83 | 151,779.00 | 230,557.28 |
| Jefferson Elementary | 33.00 | 117,788.29 | 47,890.67 | 10,085.22 | 80,032.40 | 137,120.86 | 143,588.89 | 225,706.35 |
| San Carlos Elementary | 15.00 | 116,900.91 | 22,790.03 | 72,134.56 | 108,930.33 | 117,762.96 | 124,632.11 | 171,667.00 |
| Redwood City Elementary | 67.00 | 111,480.65 | 47,938.47 | 863.21 | 76,811.44 | 118,475.80 | 149,927.14 | 229,521.57 |
| La Honda-Pescadero Unified | 7.00 | 100,045.50 | 19,832.26 | 60,268.82 | 97,482.04 | 101,856.17 | 111,029.57 | 121,170.31 |
| Millbrae Elementary | 15.00 | 96,670.52 | 62,496.14 | 328.69 | 49,454.32 | 94,317.80 | 142,291.30 | 209,097.50 |
| Brisbane Elementary | 6.00 | 86,987.40 | 66,854.66 | 2,191.88 | 50,682.93 | 79,517.39 | 112,352.65 | 196,328.58 |
| Ravenswood City Elementary | 56.00 | 85,117.98 | 46,932.07 | 3,049.15 | 46,051.26 | 91,903.89 | 125,397.60 | 219,733.88 |
| Jefferson Union High | 47.00 | 84,798.16 | 61,408.37 | 489.14 | 32,553.46 | 86,571.84 | 139,890.21 | 225,689.78 |
| San Bruno Park Elementary | 20.00 | 80,781.81 | 31,011.77 | 30,670.58 | 59,433.24 | 80,093.88 | 104,825.03 | 147,856.33 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 3.00 | 296,204.93 | 47,582.96 | 257,396.97 | 269,661.06 | 281,925.15 | 315,608.91 | 349,292.66 |
| Menlo Park City Elementary | 1.00 | 237,957.52 | nan | 237,957.52 | 237,957.52 | 237,957.52 | 237,957.52 | 237,957.52 |
| San Mateo-Foster City | 5.00 | 219,868.34 | 64,729.58 | 116,589.04 | 221,464.88 | 227,518.18 | 238,504.41 | 295,265.20 |
| San Mateo County Office of Education | 5.00 | 216,476.90 | 31,660.57 | 192,543.96 | 192,956.34 | 206,971.77 | 220,758.31 | 269,154.10 |
| Pacifica School District | 2.00 | 202,644.54 | 38,093.73 | 175,708.20 | 189,176.37 | 202,644.54 | 216,112.70 | 229,580.87 |
| Hillsborough City Elementary | 2.00 | 201,733.65 | 40,130.66 | 173,356.99 | 187,545.32 | 201,733.65 | 215,921.98 | 230,110.31 |
| Redwood City Elementary | 3.00 | 197,373.02 | 30,135.73 | 169,765.51 | 181,298.74 | 192,831.98 | 211,176.78 | 229,521.57 |
| Jefferson Elementary | 4.00 | 194,984.12 | 28,448.48 | 159,851.30 | 179,638.17 | 197,189.42 | 212,535.37 | 225,706.35 |
| Belmont-Redwood Shores Elementary | 3.00 | 175,930.99 | 57,906.98 | 115,223.32 | 148,617.85 | 182,012.37 | 206,284.83 | 230,557.28 |
| Burlingame Elementary | 4.00 | 155,992.73 | 84,868.02 | 88,124.54 | 92,392.36 | 133,229.59 | 196,829.96 | 269,387.20 |
| Las Lomitas Elementary | 2.00 | 155,255.91 | 95,214.97 | 87,928.76 | 121,592.33 | 155,255.91 | 188,919.48 | 222,583.06 |
| San Carlos Elementary | 2.00 | 153,833.50 | 25,220.38 | 136,000.00 | 144,916.75 | 153,833.50 | 162,750.25 | 171,667.00 |
| San Bruno Park Elementary | 1.00 | 147,856.33 | nan | 147,856.33 | 147,856.33 | 147,856.33 | 147,856.33 | 147,856.33 |
| Millbrae Elementary | 2.00 | 147,794.34 | 86,695.76 | 86,491.18 | 117,142.76 | 147,794.34 | 178,445.92 | 209,097.50 |
| Brisbane Elementary | 2.00 | 143,652.97 | 74,494.56 | 90,977.36 | 117,315.17 | 143,652.97 | 169,990.77 | 196,328.58 |
| Jefferson Union High | 6.00 | 143,612.26 | 67,642.88 | 30,418.29 | 118,954.05 | 159,840.73 | 175,379.33 | 225,689.78 |
| Ravenswood City Elementary | 6.00 | 127,551.63 | 54,939.37 | 77,512.55 | 83,183.35 | 120,017.54 | 147,846.62 | 219,733.88 |
| La Honda-Pescadero Unified | 1.00 | 121,170.31 | nan | 121,170.31 | 121,170.31 | 121,170.31 | 121,170.31 | 121,170.31 |
| Portola Valley Elementary | 1.00 | 43,745.94 | nan | 43,745.94 | 43,745.94 | 43,745.94 | 43,745.94 | 43,745.94 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 438.00 | 106,746.38 | 32,364.59 | 6,441.78 | 91,408.80 | 118,055.93 | 130,396.84 | 168,120.68 |
| Menlo Park City Elementary | 185.00 | 105,104.41 | 30,059.19 | 24,090.59 | 94,554.82 | 115,788.83 | 126,987.88 | 153,199.80 |
| Portola Valley Elementary | 51.00 | 100,642.73 | 32,682.52 | 27,403.30 | 83,698.24 | 111,475.08 | 127,329.18 | 142,243.51 |
| Woodside Elementary | 42.00 | 91,489.52 | 35,015.90 | 27,239.60 | 61,736.57 | 105,456.31 | 119,330.60 | 153,219.27 |
| San Mateo County Office of Education | 107.00 | 86,761.85 | 43,038.56 | 172.39 | 46,162.77 | 108,267.94 | 119,327.44 | 136,325.97 |
| Brisbane Elementary | 31.00 | 77,818.67 | 18,070.36 | 18,839.57 | 71,261.17 | 81,433.83 | 87,380.96 | 105,451.17 |
| San Carlos Elementary | 161.00 | 76,820.16 | 25,046.03 | 10,598.42 | 63,564.87 | 82,375.41 | 97,196.71 | 112,622.01 |
| Redwood City Elementary | 449.00 | 75,288.02 | 25,819.08 | 1,834.92 | 60,152.63 | 81,916.51 | 96,344.24 | 116,783.84 |
| Cabrillo Unified | 183.00 | 75,205.05 | 36,026.07 | 110.00 | 49,244.57 | 87,243.61 | 104,155.54 | 142,403.74 |
| Belmont-Redwood Shores Elementary | 205.00 | 73,109.07 | 30,021.01 | 2,665.76 | 59,466.52 | 80,115.69 | 97,904.88 | 123,762.26 |
| Sequoia Union High | 702.00 | 72,672.85 | 51,505.80 | 81.19 | 13,990.29 | 83,943.70 | 120,171.14 | 156,745.76 |
| Jefferson Elementary | 305.00 | 71,644.48 | 21,574.01 | 4,925.83 | 58,902.86 | 77,942.15 | 88,039.29 | 109,289.78 |
| San Mateo-Foster City | 603.00 | 71,276.45 | 26,144.00 | 583.81 | 57,710.00 | 77,824.31 | 91,138.24 | 112,736.83 |
| Las Lomitas Elementary | 143.00 | 70,782.84 | 54,023.51 | 95.44 | 7,836.59 | 81,882.30 | 122,727.04 | 152,121.77 |
| South San Francisco Unified | 468.00 | 70,256.05 | 24,695.86 | 958.73 | 60,398.03 | 75,477.73 | 89,180.58 | 122,537.33 |
| Pacifica School District | 161.00 | 70,103.76 | 28,779.30 | 4,844.49 | 53,541.39 | 78,631.27 | 93,947.82 | 114,053.43 |
| Millbrae Elementary | 126.00 | 69,823.92 | 27,954.43 | 5,995.26 | 52,522.74 | 79,981.64 | 94,162.41 | 112,745.96 |
| Burlingame Elementary | 174.00 | 68,961.49 | 26,729.16 | 16,394.88 | 46,036.80 | 74,302.80 | 91,756.54 | 112,808.86 |
| Ravenswood City Elementary | 213.00 | 65,991.92 | 26,802.79 | 2,211.88 | 41,526.00 | 71,886.56 | 85,880.97 | 111,852.33 |
| Hillsborough City Elementary | 200.00 | 57,354.30 | 48,936.88 | 67.50 | 2,530.37 | 55,736.11 | 108,284.97 | 140,377.22 |
| Jefferson Union High | 320.00 | 55,105.38 | 37,056.50 | 3.64 | 16,885.65 | 64,265.88 | 86,367.07 | 125,814.87 |
| La Honda-Pescadero Unified | 42.00 | 51,679.88 | 30,051.52 | 1,745.12 | 26,156.20 | 53,969.84 | 74,093.12 | 108,244.30 |
| Bayshore Elementary | 33.00 | 39,379.46 | 31,633.67 | 135.31 | 5,022.80 | 33,913.54 | 63,776.90 | 97,785.69 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 40.00 | 156,298.82 | 45,256.94 | 59,251.83 | 119,124.96 | 165,984.58 | 182,164.99 | 258,306.10 |
| Menlo Park City Elementary | 13.00 | 152,274.04 | 55,485.92 | 18,852.54 | 143,425.06 | 150,900.46 | 185,098.21 | 245,983.71 |
| Las Lomitas Elementary | 10.00 | 151,517.41 | 51,373.59 | 23,094.62 | 151,314.22 | 166,578.73 | 175,308.22 | 213,357.76 |
| Hillsborough City Elementary | 12.00 | 150,139.37 | 43,485.48 | 82,671.33 | 127,148.19 | 159,164.93 | 171,468.17 | 228,250.83 |
| San Mateo-Foster City | 43.00 | 144,082.81 | 33,332.98 | 58,301.25 | 136,475.63 | 148,277.24 | 154,452.49 | 282,214.43 |
| Pacifica School District | 13.00 | 137,986.12 | 40,797.00 | 48,149.41 | 124,462.58 | 136,397.32 | 155,031.49 | 211,025.07 |
| San Mateo County Office of Education | 53.00 | 132,241.92 | 49,358.65 | 1,314.09 | 106,435.92 | 142,842.37 | 161,822.62 | 240,595.31 |
| Woodside Elementary | 8.00 | 131,286.91 | 58,901.52 | 41,176.92 | 97,223.50 | 131,459.23 | 155,005.27 | 235,320.41 |
| Burlingame Elementary | 13.00 | 127,293.62 | 56,954.35 | 52,437.15 | 82,092.05 | 144,861.11 | 149,447.35 | 250,942.90 |
| Sequoia Union High | 32.00 | 125,952.62 | 60,181.08 | 5,816.90 | 89,955.01 | 126,024.04 | 175,617.50 | 253,867.20 |
| South San Francisco Unified | 37.00 | 123,805.74 | 32,799.88 | 46,769.29 | 116,986.07 | 124,591.81 | 138,568.72 | 226,915.94 |
| Jefferson Elementary | 30.00 | 121,266.00 | 28,642.76 | 50,362.61 | 111,583.71 | 123,939.93 | 131,303.33 | 202,870.52 |
| San Carlos Elementary | 15.00 | 119,201.79 | 45,586.65 | 28,793.78 | 95,778.90 | 132,528.30 | 139,505.67 | 216,285.71 |
| Belmont-Redwood Shores Elementary | 19.00 | 118,533.85 | 38,676.60 | 66,349.20 | 87,152.72 | 114,703.60 | 144,310.93 | 219,341.77 |
| Bayshore Elementary | 2.00 | 114,167.58 | 1,071.69 | 113,409.78 | 113,788.68 | 114,167.58 | 114,546.48 | 114,925.38 |
| Portola Valley Elementary | 8.00 | 113,462.73 | 48,735.87 | 32,480.14 | 88,535.17 | 107,836.01 | 143,963.39 | 187,476.00 |
| Brisbane Elementary | 4.00 | 104,810.08 | 74,776.69 | 19,635.50 | 69,039.40 | 99,802.46 | 135,573.14 | 199,999.89 |
| Redwood City Elementary | 63.00 | 101,719.05 | 38,955.15 | 18,601.75 | 72,021.24 | 98,419.61 | 132,855.55 | 222,483.60 |
| Millbrae Elementary | 13.00 | 101,319.82 | 54,971.54 | 30,219.41 | 50,887.38 | 123,335.76 | 129,314.62 | 208,543.22 |
| Jefferson Union High | 34.00 | 99,115.38 | 44,140.54 | 8,907.28 | 66,025.80 | 106,821.92 | 128,106.39 | 202,264.92 |
| Ravenswood City Elementary | 53.00 | 86,358.59 | 45,862.79 | 13,769.24 | 43,308.32 | 92,420.34 | 122,918.76 | 177,308.07 |
| La Honda-Pescadero Unified | 6.00 | 86,059.64 | 19,755.72 | 51,887.96 | 82,776.65 | 89,011.26 | 92,377.01 | 112,249.99 |
| Cabrillo Unified | 30.00 | 83,642.48 | 58,313.42 | 132.00 | 33,707.04 | 85,485.36 | 134,401.96 | 212,956.80 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Menlo Park City Elementary | 1.00 | 245,983.71 | nan | 245,983.71 | 245,983.71 | 245,983.71 | 245,983.71 | 245,983.71 |
| San Mateo Union High | 3.00 | 238,390.98 | 33,790.30 | 199,376.14 | 228,433.42 | 257,490.69 | 257,898.40 | 258,306.10 |
| Woodside Elementary | 1.00 | 235,320.41 | nan | 235,320.41 | 235,320.41 | 235,320.41 | 235,320.41 | 235,320.41 |
| San Carlos Elementary | 1.00 | 216,285.71 | nan | 216,285.71 | 216,285.71 | 216,285.71 | 216,285.71 | 216,285.71 |
| Sequoia Union High | 5.00 | 205,266.49 | 45,315.01 | 130,332.85 | 212,783.63 | 213,410.18 | 215,938.61 | 253,867.20 |
| San Mateo County Office of Education | 6.00 | 195,303.72 | 31,354.02 | 146,179.98 | 185,551.14 | 194,417.73 | 208,816.39 | 240,595.31 |
| Hillsborough City Elementary | 2.00 | 191,168.64 | 52,442.13 | 154,086.46 | 172,627.55 | 191,168.64 | 209,709.74 | 228,250.83 |
| Redwood City Elementary | 3.00 | 183,575.00 | 36,628.69 | 149,759.23 | 164,120.70 | 178,482.16 | 200,482.88 | 222,483.60 |
| Pacifica School District | 2.00 | 183,028.28 | 39,593.44 | 155,031.49 | 169,029.89 | 183,028.28 | 197,026.67 | 211,025.07 |
| South San Francisco Unified | 4.00 | 182,013.99 | 30,112.35 | 163,849.77 | 165,280.11 | 168,645.12 | 185,379.01 | 226,915.94 |
| San Mateo-Foster City | 5.00 | 181,844.54 | 76,477.51 | 102,810.79 | 106,826.73 | 206,916.26 | 210,454.47 | 282,214.43 |
| Burlingame Elementary | 3.00 | 172,084.90 | 84,974.36 | 82,092.05 | 132,655.90 | 183,219.75 | 217,081.33 | 250,942.90 |
| Jefferson Elementary | 4.00 | 165,516.35 | 46,559.08 | 100,234.65 | 148,341.09 | 179,480.12 | 196,655.38 | 202,870.52 |
| Jefferson Union High | 5.00 | 143,455.95 | 50,730.40 | 64,076.40 | 141,702.48 | 142,734.55 | 166,501.38 | 202,264.92 |
| Brisbane Elementary | 2.00 | 142,753.63 | 80,958.44 | 85,507.37 | 114,130.50 | 142,753.63 | 171,376.76 | 199,999.89 |
| Belmont-Redwood Shores Elementary | 4.00 | 140,034.66 | 53,341.11 | 108,009.34 | 108,920.61 | 116,393.77 | 147,507.83 | 219,341.77 |
| Ravenswood City Elementary | 6.00 | 128,929.19 | 38,630.81 | 67,620.40 | 111,012.66 | 134,809.36 | 150,662.99 | 177,308.07 |
| Cabrillo Unified | 5.00 | 119,802.87 | 79,135.06 | 140.00 | 93,829.21 | 145,439.40 | 146,648.94 | 212,956.80 |
| Las Lomitas Elementary | 2.00 | 118,226.19 | 134,536.36 | 23,094.62 | 70,660.40 | 118,226.19 | 165,791.98 | 213,357.76 |
| La Honda-Pescadero Unified | 1.00 | 112,249.99 | nan | 112,249.99 | 112,249.99 | 112,249.99 | 112,249.99 | 112,249.99 |
| Millbrae Elementary | 4.00 | 101,099.02 | 72,359.99 | 50,887.38 | 65,939.32 | 72,482.74 | 107,642.45 | 208,543.22 |
| Portola Valley Elementary | 1.00 | 86,928.95 | nan | 86,928.95 | 86,928.95 | 86,928.95 | 86,928.95 | 86,928.95 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Redwood City Elementary | 1.00 | 106,291.19 | nan | 106,291.19 | 106,291.19 | 106,291.19 | 106,291.19 | 106,291.19 |
| Portola Valley Elementary | 51.00 | 103,730.36 | 36,416.99 | 12,196.40 | 82,261.15 | 116,476.30 | 131,327.46 | 147,461.64 |
| San Mateo Union High | 448.00 | 102,353.30 | 32,984.91 | 219.40 | 85,361.62 | 114,449.71 | 126,636.85 | 161,873.28 |
| Menlo Park City Elementary | 175.00 | 98,317.48 | 27,246.94 | 16,259.12 | 86,321.99 | 107,683.84 | 118,193.43 | 138,092.83 |
| Sequoia Union High | 464.00 | 97,122.43 | 31,663.30 | 2,369.70 | 76,631.26 | 105,907.93 | 121,048.53 | 152,706.34 |
| San Mateo County Office of Education | 107.00 | 82,472.19 | 39,042.44 | 1,442.17 | 61,257.54 | 101,141.14 | 112,090.66 | 125,511.89 |
| Belmont-Redwood Shores Elementary | 192.00 | 75,600.08 | 29,794.20 | 389.37 | 61,106.56 | 82,535.86 | 100,154.55 | 120,567.44 |
| Millbrae Elementary | 118.00 | 73,237.94 | 25,669.15 | 1,129.65 | 59,877.69 | 82,400.92 | 93,143.48 | 110,617.36 |
| South San Francisco Unified | 475.00 | 71,240.39 | 23,378.12 | 3,571.38 | 61,071.07 | 75,791.69 | 89,006.58 | 123,700.60 |
| Jefferson Elementary | 294.00 | 70,895.21 | 20,457.99 | 8.75 | 59,641.22 | 76,396.02 | 86,299.99 | 104,356.13 |
| Pacifica School District | 1.00 | 68,010.68 | nan | 68,010.68 | 68,010.68 | 68,010.68 | 68,010.68 | 68,010.68 |
| Burlingame Elementary | 168.00 | 67,966.89 | 23,658.30 | 124.49 | 52,334.50 | 72,235.18 | 88,342.05 | 105,432.58 |
| Las Lomitas Elementary | 140.00 | 66,225.80 | 52,224.62 | 121.74 | 4,074.07 | 76,045.21 | 117,819.40 | 143,552.72 |
| San Mateo-Foster City | 583.00 | 65,806.21 | 24,895.76 | 5,265.89 | 47,114.73 | 72,480.04 | 86,406.84 | 104,866.65 |
| Jefferson Union High | 254.00 | 64,031.08 | 23,561.85 | 22.25 | 50,859.10 | 67,971.27 | 81,681.20 | 121,476.34 |
| Ravenswood City Elementary | 212.00 | 58,770.82 | 25,177.61 | 154.22 | 36,492.71 | 65,393.61 | 77,108.40 | 100,902.64 |
| Hillsborough City Elementary | 197.00 | 57,593.77 | 48,096.59 | 60.00 | 2,617.60 | 65,825.39 | 106,352.10 | 136,499.81 |
| Woodside Elementary | 69.00 | 56,385.01 | 49,752.68 | 159.06 | 2,505.80 | 57,991.67 | 104,225.30 | 145,463.08 |
| San Carlos Elementary | 229.00 | 56,255.93 | 39,349.96 | 43.71 | 9,461.09 | 68,216.61 | 91,471.21 | 114,395.08 |
| La Honda-Pescadero Unified | 37.00 | 53,344.68 | 27,025.29 | 2,578.48 | 31,291.49 | 61,565.28 | 70,151.45 | 97,885.36 |
| Bayshore Elementary | 30.00 | 39,795.12 | 31,961.47 | 125.00 | 2,765.62 | 49,401.62 | 65,832.02 | 95,778.24 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| Portola Valley Elementary | 5.00 | 174,104.23 | 33,387.58 | 134,760.28 | 146,673.48 | 182,528.68 | 189,401.66 | 217,157.07 |
| San Mateo Union High | 40.00 | 155,659.01 | 49,628.86 | 42,959.22 | 136,150.29 | 166,594.51 | 184,373.34 | 256,250.04 |
| Menlo Park City Elementary | 12.00 | 153,029.81 | 44,490.77 | 77,499.89 | 128,323.10 | 160,746.95 | 179,149.77 | 239,775.73 |
| Woodside Elementary | 6.00 | 143,815.89 | 45,877.68 | 93,987.86 | 118,906.88 | 133,286.08 | 155,260.05 | 225,636.79 |
| Sequoia Union High | 20.00 | 140,129.96 | 51,330.33 | 46,477.04 | 99,949.24 | 148,322.65 | 176,405.99 | 247,151.76 |
| Millbrae Elementary | 9.00 | 133,744.92 | 38,292.60 | 57,249.90 | 125,513.55 | 132,357.43 | 148,152.90 | 200,738.98 |
| Belmont-Redwood Shores Elementary | 16.00 | 131,621.45 | 42,031.48 | 57,996.80 | 102,749.76 | 143,481.64 | 158,409.88 | 204,954.78 |
| San Mateo County Office of Education | 47.00 | 130,079.13 | 41,240.40 | 12,675.18 | 106,835.89 | 136,248.77 | 154,588.62 | 225,169.08 |
| Hillsborough City Elementary | 14.00 | 128,102.87 | 51,783.15 | 30,864.00 | 87,667.79 | 147,531.40 | 160,847.46 | 221,387.78 |
| Burlingame Elementary | 12.00 | 127,411.14 | 59,559.86 | 10,957.15 | 118,199.21 | 139,275.30 | 148,173.57 | 235,077.69 |
| Jefferson Elementary | 29.00 | 117,187.37 | 27,431.75 | 37,805.39 | 110,570.22 | 118,967.39 | 124,278.10 | 193,615.91 |
| Las Lomitas Elementary | 13.00 | 110,235.79 | 48,377.67 | 16,877.43 | 78,674.18 | 106,692.60 | 156,093.40 | 171,198.28 |
| South San Francisco Unified | 38.00 | 109,400.35 | 35,598.72 | 44,560.16 | 89,841.21 | 116,871.70 | 129,125.99 | 208,827.57 |
| Bayshore Elementary | 2.00 | 108,843.26 | 1,063.59 | 108,091.19 | 108,467.23 | 108,843.26 | 109,219.30 | 109,595.34 |
| San Mateo-Foster City | 42.00 | 105,700.84 | 36,863.17 | 17,001.33 | 94,126.87 | 115,873.02 | 121,896.47 | 234,083.11 |
| San Carlos Elementary | 18.00 | 98,351.64 | 54,597.67 | 3,403.92 | 56,548.82 | 115,018.09 | 127,506.12 | 213,404.86 |
| Jefferson Union High | 40.00 | 81,511.95 | 39,625.50 | 3,157.57 | 54,059.02 | 83,058.49 | 112,827.14 | 188,310.28 |
| Ravenswood City Elementary | 49.00 | 77,946.44 | 43,784.66 | 634.90 | 48,116.54 | 81,401.92 | 109,808.79 | 195,853.86 |
| La Honda-Pescadero Unified | 10.00 | 71,033.29 | 34,483.41 | 11,674.89 | 53,208.45 | 81,347.48 | 97,472.76 | 108,030.18 |
| count | mean | std | min | 25% | 50% | 75% | max | |
|---|---|---|---|---|---|---|---|---|
| Agency | ||||||||
| San Mateo Union High | 4.00 | 230,625.29 | 29,103.18 | 193,249.36 | 214,840.83 | 236,500.89 | 252,285.35 | 256,250.04 |
| Woodside Elementary | 1.00 | 225,636.79 | nan | 225,636.79 | 225,636.79 | 225,636.79 | 225,636.79 | 225,636.79 |
| Portola Valley Elementary | 1.00 | 217,157.07 | nan | 217,157.07 | 217,157.07 | 217,157.07 | 217,157.07 | 217,157.07 |
| San Carlos Elementary | 1.00 | 213,404.86 | nan | 213,404.86 | 213,404.86 | 213,404.86 | 213,404.86 | 213,404.86 |
| Menlo Park City Elementary | 2.00 | 209,161.91 | 43,294.48 | 178,548.09 | 193,855.00 | 209,161.91 | 224,468.82 | 239,775.73 |
| Sequoia Union High | 5.00 | 194,607.12 | 45,026.72 | 123,080.69 | 192,645.34 | 202,900.91 | 207,256.90 | 247,151.76 |
| San Mateo County Office of Education | 5.00 | 188,638.23 | 24,029.25 | 161,722.01 | 175,217.87 | 184,915.87 | 196,166.34 | 225,169.08 |
| Burlingame Elementary | 3.00 | 188,365.39 | 40,581.49 | 161,795.59 | 165,009.23 | 168,222.88 | 201,650.29 | 235,077.69 |
| Hillsborough City Elementary | 2.00 | 184,538.99 | 52,112.06 | 147,690.20 | 166,114.60 | 184,538.99 | 202,963.39 | 221,387.78 |
| San Mateo-Foster City | 5.00 | 169,046.54 | 47,319.74 | 100,336.47 | 169,609.29 | 170,032.57 | 171,171.25 | 234,083.11 |
| Jefferson Elementary | 4.00 | 157,477.89 | 43,305.21 | 97,906.38 | 139,552.79 | 169,194.64 | 187,119.75 | 193,615.91 |
| South San Francisco Unified | 4.00 | 156,671.99 | 39,689.03 | 112,415.30 | 140,551.02 | 152,722.54 | 168,843.52 | 208,827.57 |
| Ravenswood City Elementary | 3.00 | 155,942.76 | 34,667.09 | 133,316.02 | 135,987.21 | 138,658.40 | 167,256.13 | 195,853.86 |
| Belmont-Redwood Shores Elementary | 4.00 | 150,244.52 | 47,646.82 | 109,660.76 | 110,668.93 | 143,181.27 | 182,756.86 | 204,954.78 |
| Millbrae Elementary | 2.00 | 150,137.01 | 71,561.99 | 99,535.04 | 124,836.02 | 150,137.01 | 175,438.00 | 200,738.98 |
| Jefferson Union High | 6.00 | 116,717.11 | 59,560.41 | 11,790.66 | 104,079.25 | 128,001.29 | 143,070.73 | 188,310.28 |
| La Honda-Pescadero Unified | 1.00 | 108,030.18 | nan | 108,030.18 | 108,030.18 | 108,030.18 | 108,030.18 | 108,030.18 |
| Las Lomitas Elementary | 3.00 | 104,582.00 | 24,919.65 | 78,674.18 | 92,683.39 | 106,692.60 | 117,535.91 | 128,379.22 |
All stats are based on: https://transparentcalifornia.com/agencies/salaries/school-districts/